SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002475 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002475 [ RunTime:0.002483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68006,1043695,767983,925452,910927,294678,621981,753889,360029,266519,14589,597248,195147,29846,990619,791853,596506,180244,566723,1008830,383617,246029,445010,519988,720116,667284,850443,447504,321313,511497,640440,159118,104319,556721,268258,549248,1035122,346682,94047,416895,450042,439751,739184,1018062,913568,255976,371763,640980,415727,683603,114183,206375,107625,481051,777854,600202,619405,792115,7223,995941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]