SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476631 LIMIT 1 [ RunTime:0.001653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476631 [ RunTime:0.007743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400747,48028,989161,602684,661667,724612,556411,166650,520097,936535,522072,694665,76978,555251,651357,778335,117290,365649,863801,948476,516130,623695,912062,583713,824383,138659,795675,815453,535347,195142,134551,268056,895053,208009,452011,338337,377355,485715,813247,328540,420149,304235,660907,15813,855788,870215,133563,753286,54323,575294,678968,483104,634210,536557,50827,1024196,1035238,761773,617052,184632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002376s ]