SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388628 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388628 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604812,749515,77348,677092,217718,568268,1008972,983188,238444,607522,237997,307533,85040,603211,79493,623602,693663,920202,896512,798826,391957,784598,1025073,1001836,672485,1039584,392438,163252,99162,79283,373098,366450,872263,733161,670652,1003348,399273,734271,745550,397601,599354,500029,518999,643703,938940,419766,935654,55855,1025637,800375,864549,804243,1036991,763918,685301,23008,970789,736842,809143,754407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]