SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487845 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487845 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523451,952122,263771,652063,640923,1023081,228808,577191,591816,627623,655251,985584,967668,60632,43598,846938,1003941,221520,303870,627692,477669,502774,368578,17589,759184,269320,734193,303055,493255,737747,39135,949703,482200,543186,296873,779203,223220,921985,638745,690371,982463,383192,305675,536522,88805,358377,138848,315683,853202,475709,677334,455069,848711,903609,1007336,32877,522290,782261,513303,894788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001212s ]