SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475031 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475031 [ RunTime:0.002511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520932,120821,324053,497805,386006,175344,575469,747135,234368,611167,281106,725580,1028223,909088,396908,417440,735639,604922,479443,459138,21520,976055,512090,818519,528404,49160,174969,1006201,210323,322723,784679,250708,999185,374441,735291,30273,759222,885125,605648,886563,612384,145357,218381,535012,568101,581909,656763,94528,6107,667951,222765,780840,783924,230342,903582,89858,642682,404091,223406,680349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]