SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41505 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41505 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818515,438543,1047295,299288,653739,785917,449332,167712,471304,134612,10351,872788,618817,797829,421479,85368,560636,1033566,461152,672747,398892,497512,677466,908144,106980,131901,924782,539459,538155,539882,967034,190830,752698,385401,647747,148980,945907,335448,642088,559742,812568,579274,51360,40108,767066,806509,91117,805578,550740,800449,629484,703161,348752,334701,56973,656746,53155,451577,245398,346333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]