SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003924s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430522 LIMIT 1 [ RunTime:0.001030s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430522 [ RunTime:0.002510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414015,255096,968629,601654,381046,479914,118349,367197,669270,691302,466984,1018288,343622,422267,842111,32760,671408,562811,488210,1044200,191925,907318,303487,701584,374832,761994,235187,280359,849753,858397,277689,519501,111251,626475,768088,932329,749533,976100,693683,326158,364068,232648,922856,774726,245625,164579,704882,1040701,234481,376491,120531,329487,323298,1000233,809978,26453,408382,636457,423213,904088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]