SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404109 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404109 [ RunTime:0.001071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284314,1009484,805768,632271,339618,327453,257487,233089,108067,383875,204420,73820,717142,9707,513312,48717,565023,339756,841470,1007919,937743,112796,19976,219067,120134,997683,723144,432132,1030787,211773,806787,360731,739221,648835,95739,120675,893646,236272,456710,567649,549613,792047,109204,838054,621318,835193,815098,1043215,472836,329303,343522,569088,623703,247653,718812,944126,106177,529246,81954,635699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001571s ]