SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315056 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315056 [ RunTime:0.003020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531577,970193,354593,152148,729101,941312,399363,83083,987894,158015,1011346,289028,814191,757654,299960,264791,943322,184992,481586,32713,763603,82837,212562,887790,866649,34992,384437,642605,537150,555137,739725,810021,564987,211116,577207,1028450,47414,206115,236886,776742,314607,114487,1038023,698231,113668,553492,879792,98105,130903,106668,970857,345706,617765,939686,110024,556770,555980,1000822,715406,1027052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]