SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522930 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522930 [ RunTime:0.001927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364387,454822,797520,745562,1017162,527891,960539,22691,235851,365218,700218,695095,777884,773189,899450,983288,283365,350626,142476,266828,1030224,759971,607331,1036641,838730,882270,61235,563119,434604,697381,324996,140811,703953,197317,204958,896969,287302,569536,251103,85388,751637,243395,894040,918485,584356,1025139,980646,382559,569482,1014914,498267,631091,1016141,661390,985576,954064,46973,253182,332569,184251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]