SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018580 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018580 [ RunTime:0.002926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399882,469093,414417,345457,716335,392244,168499,454180,972689,500624,811680,184807,763716,638988,627268,1027471,419052,130812,103894,538742,848709,372703,267820,196514,382905,562702,162395,661610,115290,352890,220786,890962,299267,130285,375578,773780,358545,870406,223245,175491,394934,435664,455617,477720,777538,296856,548701,562946,410981,389621,58722,141893,946095,279505,985878,571241,587182,661079,778010,140492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]