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` = 1014018 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014018 [ RunTime:0.006838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829351,484812,872563,895679,541226,102618,17383,348638,111540,750382,151927,594086,680061,303738,876394,104754,294983,74050,741424,913068,150973,415515,105701,485605,168230,258197,480271,274316,397462,229742,402846,940718,682703,1023357,364760,767715,869871,225595,739030,149272,527696,153850,980396,209153,724735,833808,828328,294752,54674,625959,106814,238366,301804,1023441,498354,369837,520135,623360,364690,1008278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]