SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034250 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034250 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782318,545253,68217,944604,29411,118222,977767,1029741,221824,282141,380197,835590,807275,352587,832486,874930,286903,203945,887229,725415,255998,341916,450704,835213,811512,246914,421197,451030,271902,579630,455820,1039983,153877,421306,940804,565142,447662,980615,473911,143380,170635,818021,441159,215620,853087,1012758,277971,416770,801834,747795,402380,734795,359057,893839,891246,824374,758387,654352,177648,434615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]