SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034801 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034801 [ RunTime:0.003517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614450,554213,508792,658262,758857,999175,630075,304818,405515,796864,216710,1037480,449884,422873,577108,847892,55241,471900,517767,283727,814450,460889,641128,63822,642670,743580,690474,1010203,863098,838914,681447,675370,84778,1032443,938607,482007,63331,561638,893501,18259,100126,806025,867109,813399,116909,177710,462281,306791,58073,321749,102763,254981,576516,609883,507319,19414,962536,492265,272968,175632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]