SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509395 LIMIT 1 [ RunTime:0.003378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509395 [ RunTime:0.007163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552429,289013,171255,5455,674393,147328,262129,165529,368913,325139,584813,353172,76375,368912,160107,182581,792253,756311,474632,57128,330722,403095,44338,973089,14854,300029,734074,928049,346367,231794,200897,798999,127439,466589,714383,257847,438459,641858,793093,215145,993791,1022488,665661,620988,799627,1001068,1002498,104290,670963,1022212,767598,419517,381312,484500,691935,514906,966109,211207,101914,308418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]