SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509690 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509690 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353891,217181,332962,232566,313856,177112,274756,279041,709968,698430,971766,9055,424689,916345,841316,1044727,293959,1030692,947132,966742,1023013,516312,657079,588322,1046753,495434,115467,427874,607663,3338,150040,241552,586492,627233,542817,126797,82621,176058,357812,427460,875784,332048,677909,676904,257204,724477,990914,875689,178059,1024114,119192,634420,636873,486207,689889,704192,642491,515190,842641,404759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]