SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516648 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516648 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552003,703337,118290,363751,955034,269296,1028673,122818,395526,349558,916348,801882,615505,655507,330140,407639,128395,902696,131850,105518,641447,942023,716981,777077,676869,457034,465135,44421,541314,461185,540150,429922,395223,697411,676099,405337,514388,735477,731313,676197,509016,434235,795016,657569,663501,254369,865029,231558,920176,813225,332198,121591,816383,218141,654178,632135,600718,178097,266018,836537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]