SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506888 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506888 [ RunTime:0.002184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556039,471129,866192,118337,792606,815197,829163,338467,282721,480572,262447,227746,821295,3526,953391,1013640,383939,303811,96926,505659,161991,983648,114799,290441,324970,28443,146712,628672,108596,476313,882746,684211,743312,555089,211425,561091,538692,86606,480768,824816,62529,996795,947226,596668,165663,292072,592659,740755,248372,1416,462925,641066,491536,275156,552337,195091,785771,285215,65752,224486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]