SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004382 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004382 [ RunTime:0.003194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040274,818362,267648,269704,212194,178324,322641,294286,239416,283929,1035192,1040693,342915,598102,481876,759928,645270,253201,808536,174865,294674,184359,378507,1036572,979289,53126,911305,496989,350052,199999,492354,932037,349764,552903,346382,782898,135744,239683,120935,181508,286199,710336,490620,276017,235016,261198,855626,817876,513002,741265,1023941,818887,70093,61200,269211,648756,1012681,376771,218628,711297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]