SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4809 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4809 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332431,882366,724303,867951,383307,579431,574050,199927,783862,298824,969800,355602,312691,154488,1021316,348323,27303,943556,1043235,964442,978252,293168,770103,322327,541007,203330,478381,842394,590137,955555,581681,217463,568813,54861,568018,817880,473358,558596,645072,792059,1019218,486487,1025284,707688,510048,448402,812247,482878,122695,297139,291083,783834,239559,784215,224944,703449,989978,997510,897513,288017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]