SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105197 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105197 [ RunTime:0.003292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288596,205540,67712,853338,877295,362312,750873,849837,508843,244464,339344,773091,1044121,262891,254063,891081,827440,968819,967315,527900,799944,952026,911602,261648,281023,1043576,70791,970848,998564,142838,12205,564049,335123,481311,715994,60343,152249,126173,763220,379485,719313,868621,275055,39402,392640,99380,1019412,1035004,334078,430094,163016,643696,720415,654308,259458,954086,348434,439498,17322,491861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]