SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620380 LIMIT 1 [ RunTime:0.000556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620380 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524044,22185,325411,876033,781318,538925,108951,595681,956895,777716,288420,290815,406403,63805,671606,318071,226744,961229,1038846,959386,746637,33731,479751,718959,100851,411592,361798,149906,652540,131903,262032,201592,415854,208115,734497,704522,457506,300297,87412,429717,433597,832624,577450,1024861,620000,541428,933555,510272,192562,539988,330478,216083,927409,70314,54428,486435,463516,614168,425181,951769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]