SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402421 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402421 [ RunTime:0.002301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409766,64073,760149,123605,993145,58477,966945,80865,125125,487606,650271,33580,38889,77097,845766,693704,104180,823860,728307,398336,588942,434456,178908,39306,845656,575678,79303,857898,373886,524404,337431,1014253,334852,241190,987775,607889,66907,244635,610936,768413,117511,839704,937924,369993,897837,785531,243285,510651,483810,840004,765980,124570,409993,958513,558962,361882,442976,716346,265878,502112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]