SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200302 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200302 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142873,65980,324160,147636,398521,40875,100504,1040651,503637,145709,976270,194469,649405,132940,523391,963812,336467,110447,55713,1004626,372139,119906,34043,613806,392496,261098,999635,340058,106155,681432,988843,581186,743270,717902,45632,824210,511966,322787,203419,413911,903737,49726,967076,1013126,672440,869042,287897,881282,397724,13147,747885,85248,805612,446933,323627,464186,270599,574797,1009876,984596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]