SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405231 LIMIT 1 [ RunTime:0.001310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405231 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183267,436254,743602,223754,302431,797103,511509,758102,203086,47928,8057,209378,396975,617728,363832,331181,566742,351518,901184,123951,570258,131404,13958,653145,518865,432940,78778,614217,583403,869985,116769,929224,459175,526680,737768,573534,866800,842039,550888,257160,43697,32655,169070,794360,183921,299294,967960,1018239,638837,55071,452976,553693,757859,939543,58670,46718,463959,439420,332283,611214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]