SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405654 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405654 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838845,199703,781865,56746,22985,431259,793701,609942,446964,919419,908160,306087,110145,297574,907815,273202,835783,772725,811169,724719,57957,1005709,138843,709575,106034,897731,550835,33306,936958,179755,357832,115126,865519,39395,822327,1002072,1018518,820105,773166,828792,727902,433493,509491,291090,988920,914592,842360,401784,115869,287500,479452,307838,323359,808433,906271,340333,893459,644769,487939,409927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]