SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289013 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289013 [ RunTime:0.004496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045274,895854,44092,995100,40956,767625,173149,659575,612516,728139,168921,92433,925094,45764,63630,575632,1028573,629012,1024515,989328,587737,433097,719374,659988,600044,1046984,33862,492230,110483,7761,471628,566512,401898,952418,374587,951302,321617,936103,727414,441649,944663,86341,859601,588779,974853,304527,444397,762531,382405,69548,288683,596317,749588,607912,162994,656536,560424,730235,786963,1020196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]