SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 761016 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 761016 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321157,258628,241903,646385,417448,1024028,10512,36828,803355,978981,958742,732654,134880,932699,328859,113649,269612,517469,1021198,686606,1040607,476429,766112,972853,303460,48478,674209,939469,391041,156706,939899,846615,953241,751891,632604,97100,390691,611139,61049,620925,412212,264044,734507,764721,203297,339024,704259,1009870,23341,785343,984064,468662,799832,966903,72245,111685,572367,485740,460196,262540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 761016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 761016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]