SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584480 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584480 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484843,733,385962,537241,555035,131926,712039,652261,991138,275687,817228,733040,506526,532622,929642,681787,743823,608575,472349,271656,100029,612309,709128,622116,168218,63741,217985,655728,303407,342842,194979,14997,437139,198130,427670,837350,587349,252200,48920,852045,748948,360863,421606,100848,5930,544160,492441,865088,801735,994621,555213,708945,129227,961050,75752,296781,388530,979656,836902,143641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]