SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201412 LIMIT 1 [ RunTime:0.000606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201412 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268645,683941,240459,165946,359945,800027,649125,517051,706604,413828,756182,743619,554037,126020,414265,472252,267728,677221,122385,576735,487488,539684,506582,102080,25772,956782,427176,81153,425966,674471,933641,25637,361346,19638,958184,509293,876406,312247,478439,776683,453210,820698,605773,527188,313840,2411,385779,485496,300586,376250,226790,505494,570262,204799,375123,962976,473477,317028,1037416,929647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]