SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339287 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339287 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578929,448145,1046641,614697,762615,398821,870975,452676,591733,839743,526375,762480,956679,619723,60742,633761,823990,545606,596768,819223,355688,713149,696363,526348,444578,965399,169940,609480,676009,710819,119338,687212,706144,784474,482682,997819,115067,601026,163199,285377,114672,384639,342355,648729,265662,664667,620534,561503,120882,481784,291468,428731,389439,930025,531602,705188,213619,474790,118567,248963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]