SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261572 LIMIT 1 [ RunTime:0.001190s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261572 [ RunTime:0.002852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702887,129981,177334,464438,389373,375429,409173,684454,777829,708813,599127,438373,112348,390356,506420,989700,867260,313617,812877,712108,452235,430309,719576,13098,309776,766106,373391,670545,222514,193652,970490,641186,690470,372640,503291,40396,501107,1047555,415454,787130,869355,924845,590509,228833,1030289,962814,153390,774438,594877,684616,39613,764085,166477,125028,806767,737869,562798,140014,705016,445214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]