SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20105 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20105 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302555,979193,510985,372968,926273,411711,871565,202540,189412,408101,202379,777088,203862,689150,62473,1030973,231011,538984,18628,124470,824004,747322,811232,1033458,6263,393316,514076,270620,782780,674779,228780,643089,503397,1042967,136056,653934,655605,526228,69626,372763,370907,558026,494748,611632,320824,763220,813225,235352,1042868,72901,106726,495338,859769,279324,638558,507876,416407,318600,9202,952752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001052s ]