SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014624 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014624 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23427,89576,710051,188055,584889,294459,604362,581978,274578,536191,874754,21138,818131,778112,46578,542060,142837,529921,162731,782792,940143,87854,1013812,879820,831175,558793,981626,263210,495824,948129,265344,548310,465241,1026781,368345,459851,127418,259967,419205,625069,605573,645625,63853,795231,293924,692815,1008304,953395,789523,558445,961325,623526,22699,202540,1007875,365406,665347,826540,984680,609949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014624 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014624 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]