SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023522 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023522 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593983,792973,811504,205517,871406,888779,323667,404031,270263,99922,186691,491320,544820,60570,840046,804905,491875,573549,914544,114,563887,48605,20586,237962,118286,107610,58930,886356,10955,45132,318193,870418,385157,383978,16325,586732,996273,442921,268934,716456,241169,712877,253471,615062,970379,11472,820775,1039521,661840,230735,294562,155052,774785,625163,6507,658509,706344,67228,1007858,175099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]