SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014001 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014001 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953940,494065,250291,758991,454257,844941,680991,99261,229027,83059,562491,126218,651495,417611,669034,92875,322119,440287,155907,241566,116690,867639,351516,1046779,459852,84744,427598,300753,1029295,113907,335427,212791,852957,728030,853269,91520,240450,884944,526107,909453,339705,978362,323385,869326,712588,902169,778104,697881,20363,360506,710911,554379,123205,541964,556670,799568,964547,381625,638020,18636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]