SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45885 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45885 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543889,240866,29204,996796,391974,23988,414542,568425,956295,666097,294665,90412,304018,769572,910583,212442,525442,1013668,410476,92142,51502,195933,681976,154765,653304,227888,101822,512138,725181,521181,43531,160186,168130,66318,123660,490405,998375,39693,344107,120606,599635,62358,104472,36670,863132,268004,122422,544096,918283,93334,521576,372101,200075,28747,704989,292723,643746,305750,498380,530248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45885 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45885 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001246s ]