SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546425 LIMIT 1 [ RunTime:0.001632s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546425 [ RunTime:0.006751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10284,874429,745200,427960,75822,375430,899932,513908,730634,110297,41339,501442,862868,724995,184388,677486,341739,73139,643172,193112,969977,28806,499660,253962,894265,792466,824242,91466,516024,418462,855229,1016690,212355,814021,50025,91301,167378,133366,262738,887436,405294,557486,695889,1004373,564253,368878,615988,583930,751871,974632,932967,340802,248191,570594,306630,17404,121688,107109,549712,714689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]