SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492016 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492016 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985293,340444,179674,864768,222687,839722,967289,641898,902709,858722,297510,956584,850789,834296,491960,482902,624216,937801,472012,41728,468663,561576,541109,540979,25459,593192,1044013,339454,119263,246750,89160,271625,924396,743055,755746,818259,196446,642332,138749,680885,865638,999709,497449,991255,67316,675784,118522,304055,120558,478616,523418,627785,157597,393263,352558,747956,930574,618609,194910,380705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]