SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261321 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261321 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040022,177513,502992,696094,8682,819723,865856,336700,306699,47490,130025,487346,240583,744866,303000,394515,692579,119930,943490,1020774,937415,1029825,912281,853830,539417,7105,826382,262705,318780,737810,277867,1018269,149278,379060,858698,58669,256968,228645,11502,546435,1009140,126099,961159,970569,485994,316190,649834,340902,364724,357172,620291,451281,597429,518438,503026,385006,438409,1033338,655005,772366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]