SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971648 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971648 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367287,220734,120157,615607,982529,271625,47966,155001,302140,445423,359875,693524,409826,852696,144023,877230,34953,807086,308355,69462,553399,1978,75107,318110,179031,399210,642002,415366,128500,858098,461833,2139,428391,282054,160950,745573,1017612,690564,643955,128849,1008998,883426,931947,482397,214485,782105,109534,967572,201354,617778,719132,939101,850774,242848,156940,979957,617525,232935,637279,777062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]