SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40148 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40148 [ RunTime:0.002483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396175,262834,71860,105081,283131,1014402,430978,219720,126586,593481,785999,203307,135094,4211,919680,496161,299176,1007564,254980,590693,773933,298785,124656,945246,903398,250101,206725,676120,696101,459508,813723,530065,819624,471764,230814,971986,784104,551465,544794,635974,462046,141579,853674,971365,187100,1029557,116034,671645,669729,826711,311569,521867,859701,674442,119786,249330,338137,12817,418061,75080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]