SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562946 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562946 [ RunTime:0.002576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308176,901033,612386,45841,810618,654453,362280,159969,445590,683432,678594,731954,436687,253442,234854,548071,1019107,479084,153750,264845,591771,305474,170623,914038,562083,130786,5264,637703,119216,146304,256003,496264,923750,381722,785362,439329,276883,636527,724145,582443,790796,178520,882083,941039,637972,1014667,12032,5588,529874,636744,772702,625614,895549,228559,1019757,45399,905534,676211,183335,566823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]