SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529810 LIMIT 1 [ RunTime:0.003581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529810 [ RunTime:0.006845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408302,375954,204059,752649,293198,220643,16776,211145,377333,679774,245197,956024,188590,929088,368745,946783,329853,890160,987331,604915,234813,70406,784116,478304,941165,165917,173472,663296,913537,684148,105365,703211,512793,268403,226781,25645,427988,105620,208526,229342,421316,361622,948546,380237,822020,693509,337864,402924,165109,467396,640154,177070,1040986,510191,506397,477305,930381,1010320,583203,780275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002184s ]