SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047746 LIMIT 1 [ RunTime:0.000792s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047746 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675272,571710,936853,1029255,30046,690477,830627,766371,363370,798846,568609,381893,800318,364115,753867,935390,854861,459811,563098,497668,1046027,787293,516309,470580,604677,982091,88293,582898,351895,122474,193275,251460,846954,458348,615480,838404,109820,196978,497505,43357,712686,558632,1031190,88058,986527,95396,116150,277512,66693,803458,683586,549944,265293,114247,493092,404077,581496,148876,912470,171865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]