SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047410 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047410 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275929,642242,134250,848214,351882,390358,553343,1020931,137007,879507,1041167,932730,246726,339078,720349,132922,890982,10420,170542,755890,953787,908154,501958,345322,905334,576068,415045,107113,855019,212743,375223,776604,191881,472692,657470,170707,708336,185669,449688,863575,551069,78128,633169,486637,818644,990534,340336,909222,29848,175244,307691,573580,601910,630742,799564,622211,192844,514557,491297,534307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]