SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114112 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114112 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522295,577601,350505,602921,336857,879192,11389,761020,301352,210149,877876,855966,784558,1014711,182862,35659,94871,140866,405026,539658,422339,461552,485959,810320,1004977,628409,4967,1009013,992320,20752,836373,192113,737550,140131,669102,747405,891453,685238,922612,87149,697231,977494,218320,240856,197905,1005081,361011,551857,413311,593446,273543,277934,466132,166738,752469,912576,121408,45307,826995,486352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]