SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104583 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104583 [ RunTime:0.002960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607875,159906,348614,773237,961630,214598,683340,712190,197576,226200,113541,372014,668043,819707,63027,109190,922894,822469,960340,95185,924104,820268,913105,75257,860048,770735,795180,499020,36874,606743,865137,568199,30320,965679,46699,440469,602218,553255,123597,163555,896277,873863,1043895,471826,812265,530409,520106,325886,228799,673389,287626,740724,698449,56912,144243,302329,1023593,568829,444463,794948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]