SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003592s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030516 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030516 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707894,810235,726041,558195,318317,1021033,894519,152337,465909,724084,252474,511974,609609,757566,110851,148589,426206,217062,464891,62738,804822,481778,196047,402675,755976,140854,701402,80725,449286,63309,294438,301374,1026739,608474,983209,724489,204175,253063,465785,856065,328732,941290,688390,711044,729521,505325,258406,429792,915877,958467,424976,503715,274312,622833,865615,503034,239677,276421,993419,462992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]