SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283913 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283913 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019717,148640,557088,474100,700255,447074,416695,171618,390695,1008307,180244,591286,992435,485302,746863,340377,331432,232775,66379,328459,402982,868168,143944,487487,539770,273490,41286,385578,301555,995879,148352,807936,298703,915137,40450,601221,80700,927346,226060,577823,769476,286077,779269,41484,872964,701626,865190,222694,978112,678778,807677,542878,431595,717489,414501,192866,755531,123443,643079,495463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]