SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471721 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471721 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849829,33377,911024,835253,227367,1003540,620064,293511,852384,692093,285031,940199,189110,74534,544995,255393,103330,252655,92059,346065,8024,3673,372666,438766,613462,836988,103100,630199,942909,187698,476020,816367,922348,557867,471402,552439,377157,203664,692773,25292,305089,754174,484805,564104,188725,116141,1003957,411825,741447,272286,180904,47557,962758,217513,505430,584623,94045,920723,730411,914659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]