SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5584 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5584 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524811,103840,601968,1044327,627419,517463,395043,548121,970609,453876,527797,1011490,164855,181313,118330,245556,87458,112010,419949,959593,154226,202196,477081,788273,808608,120756,149031,920058,617161,436840,597871,467709,142372,967781,435704,865494,1029412,38722,648694,708568,880192,893133,264401,13151,762538,65973,946672,691983,510210,938258,202679,897617,821287,975978,27502,50690,1026557,1028226,983448,247115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]