SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036041 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036041 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697306,316803,741092,799947,542866,702038,334312,966605,430514,600150,865290,318849,705646,956490,760127,615752,696312,875013,452269,809925,467083,248195,440513,533825,125606,75606,213214,81329,154327,306335,556328,42857,694703,838885,197158,478410,101030,777140,367123,173730,970688,356724,411366,505077,471598,101264,686317,128509,83418,512745,429883,380006,20306,966437,842625,944224,929053,839348,489000,162412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]