SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314891 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314891 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71425,473603,353637,869374,52400,368593,580235,408269,870209,438547,355480,213309,352735,261168,565002,1024361,886434,404959,338367,939739,282367,204806,290731,584309,2654,1042076,213013,357401,330357,348568,192266,167027,397360,1035536,584519,205736,400804,590553,517015,1041577,92525,233294,96258,224880,741506,122558,256395,585092,472079,656610,189251,487787,205835,590255,545290,223988,753129,823132,141849,248863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]