SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 246813 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 246813 [ RunTime:0.003075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383727,164421,395530,466622,1021450,1039730,78967,931228,250825,350539,247067,758375,502589,917891,962279,218573,1044892,256513,598400,386213,712638,285395,597654,118093,675439,737364,867015,647924,557590,507234,269195,134309,252931,102590,342111,418347,846910,123193,91593,539472,575584,793774,550848,125392,249183,582300,849442,1007500,270036,877296,848503,63444,1010159,868353,568051,619559,960796,254118,475718,59935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 246813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 246813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]