SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1311 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1311 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441751,177624,846986,541550,832971,357894,823041,541533,181190,856840,722005,808619,838063,1032768,548423,60654,291202,1031051,355852,696089,267127,56909,154907,503766,21487,184583,441653,830490,545629,659047,991220,881619,133728,211720,255096,692137,737998,644135,706034,432335,779207,657226,104232,535829,512985,985902,13943,534024,187774,350011,118444,831903,744094,618790,328970,519464,137016,110507,718533,468869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]