SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004723 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004723 [ RunTime:0.001424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808460,28993,660120,899657,188370,202780,240700,1020999,756685,117106,756743,975713,252166,554533,671044,13400,288965,604682,625542,193501,783077,128008,854548,519823,674243,962992,167252,117699,851305,1028898,245644,205432,552088,7772,341056,916961,958063,472934,274456,811594,18715,161311,813800,326894,704335,409134,986516,856916,163089,315452,488908,732831,589974,378829,710930,133995,176428,915205,623769,359311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000871s ]