SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501300 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501300 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738480,120800,59724,563097,1034412,422315,304098,517373,422382,29368,452375,354660,770439,729977,751705,725998,834726,337623,797686,148062,219464,1003367,1003412,469927,920578,57196,854962,468143,185478,472059,828432,869157,54109,259474,577589,308875,88135,665022,216846,1008802,868001,505442,571377,138045,774474,861862,110977,669171,593046,783983,908359,321714,906054,1017312,393686,201667,173801,53311,125203,572392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]