SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 665573 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 665573 [ RunTime:0.001452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940120,1014569,653234,739078,321823,1006899,360431,436449,506976,373060,472092,473894,34235,952836,548427,792443,509024,951329,702394,479194,148944,282922,346713,67815,143125,321254,238312,477586,1041548,161835,89475,993094,265055,161989,640191,677864,953146,844631,277911,784797,487433,551786,328184,712029,377688,102993,467597,883017,20008,195884,322954,552994,383779,646369,33835,923921,396147,402024,498057,556293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 665573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 665573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]