SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681828 LIMIT 1 [ RunTime:0.005207s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681828 [ RunTime:0.004532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480914,516701,881611,388738,744487,533222,701392,301433,353827,978226,456487,360612,959691,1019910,454431,390921,759381,399545,409376,1037005,172126,605528,1019366,107769,642197,162154,768410,764947,750490,160578,736424,287299,899881,39083,422789,922097,810624,1018780,834711,189828,697947,732004,867582,613816,271694,807488,719247,181126,519080,272191,837809,1008042,830974,644497,836170,523150,24697,991522,806518,78613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001123s ]