SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574943 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574943 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64986,736832,1036806,277685,657001,168094,448280,594628,962948,609280,637094,169548,461703,604744,612553,585436,675226,919333,194045,763504,983037,821301,645220,577041,727973,816719,934247,472221,227513,330152,408002,285947,625099,288160,571933,993523,202812,507244,144416,188764,1021212,794879,824587,912063,751575,512528,971800,951635,385455,822921,659443,803115,499911,566110,1043051,392878,698386,639070,356413,492100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]