SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001929s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520370 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520370 [ RunTime:0.002683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406551,973989,1025214,334986,681417,1036152,804998,737976,429491,740503,909775,546717,168745,461325,217858,840871,449046,42713,1037218,776244,142387,212013,977748,725887,985741,487387,452922,142881,82234,267557,328703,906124,706346,849316,847224,1021163,795449,881106,98132,61047,139691,64030,704632,184121,66031,188948,310755,883555,666627,784344,304128,285964,340143,205858,307184,993636,212084,744924,266458,404755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]