SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406961 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406961 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87754,644829,628207,790522,380067,709683,614609,503077,772582,1025848,992682,63714,315765,223089,901098,1036786,891925,995844,469129,771745,713969,355229,862281,998067,892880,28273,521411,598577,797782,727959,284373,242058,944367,613287,681596,404456,349191,1022283,335610,125415,784095,428338,9285,861997,757463,719187,508509,181205,374349,1010172,508913,264256,727557,187328,755052,934103,623091,248774,829764,446576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]