SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004020s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405063 LIMIT 1 [ RunTime:0.002193s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405063 [ RunTime:0.004126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997683,171054,891952,931848,47170,90252,18296,423231,797955,20776,161397,248908,705787,258424,401524,873677,840418,787094,725059,427321,79947,682235,853034,32499,343100,377597,908754,7020,975210,941707,416329,681787,950654,319599,724217,474733,699781,948410,259588,265578,1032163,36971,308526,347834,61615,135261,222899,422412,654300,531529,863980,194312,268354,604091,943317,557881,191605,29550,409573,928384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]