SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503151 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503151 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455981,667347,976672,619690,1002826,33574,218332,207062,498641,894808,623295,28761,496573,139341,549411,629953,906993,104913,1026903,5994,856698,657750,276661,169622,976853,580644,1008870,732023,49911,239468,392525,889344,33963,344632,935377,208593,475048,885089,584635,287823,18299,187978,49402,6652,852330,277340,550366,892213,806849,134143,1032672,300270,244528,53026,134032,964412,407664,55467,388287,800417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]