SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521712 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521712 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732013,787850,176796,427541,552178,522564,846728,899773,921701,126292,242903,459935,282587,589455,884187,196188,968815,235309,958648,172887,235179,493541,822178,277069,697006,1008509,715243,942847,975768,88230,393354,523418,190176,484323,485202,411387,269699,966116,829809,582236,632526,897867,530010,571755,13495,365989,373373,252228,1030330,897546,1033019,57519,397053,573368,50633,231759,233101,593461,294889,189940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]