SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196840 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196840 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432863,701076,887028,9663,577319,277108,740241,767718,20050,729084,559452,257654,191815,127147,477552,927827,538169,251862,625332,416882,798387,733471,162136,100518,675044,816309,843736,188884,202376,990057,615992,1011347,55202,681711,90418,856071,386973,1005906,895921,376369,942599,40206,303863,865781,416856,841436,451948,915815,712397,149865,142876,127670,384449,111399,287912,80016,118399,833312,716393,902221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]