SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548511 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548511 [ RunTime:0.004761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220975,145111,133847,271,929506,733709,879093,400601,1007924,380801,180844,95425,748952,65617,391336,118760,654114,923301,406490,1039555,149300,504592,686409,166724,221317,731686,445254,655219,284930,988046,935122,168487,685655,669402,561465,1012812,864349,988597,595811,396838,892504,405677,283734,341853,876515,780313,1015890,65750,744498,93043,271336,164520,686059,759990,154547,699268,978117,958269,319697,655190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]