SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522080 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522080 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289967,142881,3358,14683,506036,996017,1029205,541857,586414,206616,1028979,303055,1045414,675336,5527,14124,822253,518730,96471,366113,514497,138724,182933,858472,736133,199558,71079,885816,791909,61044,890193,61206,241885,608111,200852,357014,421225,791821,829346,1002722,876489,1022969,949149,231316,162232,420691,919414,857311,62713,168722,290484,296707,293666,89709,46429,360447,861035,985307,245352,209152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]