SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802801 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802801 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848087,60473,365468,877617,686371,444373,171042,601247,656240,719099,610854,862507,377522,937833,565809,37354,928365,1047538,304932,276126,230063,684996,966559,61910,529679,75932,1026830,296226,981965,981653,410280,503884,651236,167364,421740,596289,954696,246502,495205,167956,722481,237542,660351,787978,322085,548703,285877,979178,14910,416130,806598,192009,612830,842462,735448,435669,787761,640981,193896,449744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000765s ]