SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567540 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567540 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046545,1033311,1040769,103524,885052,501323,276854,759041,487059,852304,350073,136989,218892,490375,547110,958705,112138,662629,418980,946587,252991,109643,526089,778171,958987,536536,538013,77640,354202,853698,13562,924959,917704,1048237,1028828,808179,1095,673092,739359,560092,603238,691119,881115,55680,407752,646006,643866,592048,520683,257121,105034,266493,242080,247451,62312,282007,553349,536099,116957,644799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]