SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41967 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41967 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211762,798628,677801,460992,573194,21958,850386,576968,286319,990351,88694,377678,381828,31243,453923,146537,26407,192101,326153,113829,547233,177380,663278,502429,702503,113535,642345,503261,762280,274646,791116,316099,705924,624959,430565,1030556,556240,1045901,160404,213553,814023,280144,874408,208492,15139,696223,540066,815920,801512,568861,994802,826229,368760,586475,425959,81837,888871,987398,704709,1027173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]