SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497101 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497101 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506929,951054,868842,984839,381339,242322,643060,931430,172386,735618,501757,145649,183152,844462,347479,310192,947019,772305,990314,1040596,752074,141858,1031513,672693,686427,995337,347996,806745,982916,934190,990486,1002016,768445,11680,895147,554931,115676,506633,199802,931829,349311,966532,469392,177327,786802,433202,212523,764226,152223,437905,391050,217232,746694,971100,908560,880535,694329,660130,1030581,846841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]