SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72120 LIMIT 1 [ RunTime:0.000720s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72120 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812564,605270,322882,265409,1035482,19259,209130,774185,367288,816766,317574,654867,969513,21389,253850,186805,1044242,137936,871236,1027034,233690,731418,29157,472265,490729,443487,166448,134658,893030,663965,685663,643617,487671,101625,94842,891938,118050,634415,80771,954714,469948,380094,434283,348397,654890,897045,895207,174794,673392,921471,1048098,987877,482312,384656,692301,534812,426095,99368,574793,602135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000837s ]