SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31143 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31143 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038465,543337,860207,238605,1004142,77307,62024,117750,686222,352414,383317,440477,600194,414703,503853,833820,965854,850053,312563,531411,604582,882056,674883,1007444,358133,36582,41188,1011962,53762,190659,121283,848589,1019810,865596,374680,744244,733616,50788,153858,432920,952087,50706,838040,719246,51095,462225,246029,114085,772139,827140,958491,964869,303854,1037983,142109,426035,968487,691785,796982,170859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]