SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450561 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450561 [ RunTime:0.004601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840905,253121,136932,1003138,940585,36431,219356,700350,887437,158466,144391,614077,653648,21485,95577,358284,494762,116015,250935,342853,158168,810479,521150,774350,59871,156705,895654,1046704,1006,280530,1038278,961884,643395,393681,919547,548813,460330,72111,729115,678132,408283,164835,134985,1002016,679727,494153,323433,1000970,779418,416416,740932,396268,74125,376732,844650,997279,802682,450204,573263,612944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]