SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001877s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343006 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343006 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001578,131124,871064,999686,662681,542812,285039,562452,817839,881475,132995,580004,219261,744238,450820,833203,660868,593640,347250,472265,560315,389047,798756,392809,140366,701172,1008416,406504,549939,83000,150,643582,961984,475966,95477,365210,571864,283397,66356,31460,821949,471021,1046095,1021308,98544,91822,155567,814182,571647,262964,383568,264435,712637,425104,736991,758631,656166,25780,732765,60757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]